﻿
if col_length('dbo.ERPStoreOffersOffer', 'PhysicalStockMandatory') is null
Begin
	alter table dbo.ERPStoreOffersOffer add PhysicalStockMandatory bit null
end
Go

update dbo.ERPStoreOffersOffer set PhysicalStockMandatory = 0;
Go

alter table dbo.ERPStoreOffersOffer alter column PhysicalStockMandatory bit not null
Go

